package com.five.community.mapper;

import com.five.community.bean.Complaint;
import com.five.community.bean.vo.ComplaintVo;
import org.apache.ibatis.annotations.Mapper;


import java.util.List;
@Mapper
public interface ComplaintMapper {
    //    查询所有报修表信息
    List<Complaint> selectAll() throws Exception;
    //    根据id查询信息
    Complaint selectById(long id) throws Exception;
    //    根据投诉人员查询信息
    List<Complaint> selectByName() throws Exception;
    //投诉页面一览最终查询
    List<ComplaintVo> selectAllF() throws Exception;
    //根据投诉人员名字查询
    List<ComplaintVo> selectByNameF(String name) throws Exception;
    //根据id删除条例
    void delete(long id) throws Exception;
    //插入添加操作
    void insert(Complaint complaint) throws Exception;
    //编辑修改投诉信息
    void update(Complaint complaint) throws Exception;
}
